CREATE TABLE [cms_article](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[TITLE] [nvarchar](200) NOT NULL,
	[SUBJECT] [nvarchar](200) NOT NULL, 
	[IPLIMIT] [nvarchar](2000) NULL,
	[CONTENT] [ntext] NULL,
	[IMGLIST] [ntext] NULL,
	[WRITER] [nvarchar](100) NOT NULL,
	[PUBDATE] [nvarchar](50) NOT NULL,
	[INDATE] [datetime] NULL,
	[STATE] [int] NOT NULL,
	[CREATEID] [nvarchar](32) NOT NULL,
	[CREATETIME] [datetime] NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[IMG] [nvarchar](200) NOT NULL,
	[SOURCEID] [bigint] NOT NULL,
	[SUMMARY] [nvarchar](250) NOT NULL,
	[ASSORTID] [nvarchar](32) NOT NULL,
	[DWID] [nvarchar](32) NOT NULL, 
	[DWBH] [nvarchar](32) NOT NULL,
	[DUTY] [nvarchar](50) NOT NULL,
	[ISOPEN] [int] NOT NULL,
	[ISDELETED] [int] NOT NULL,
	[BACKDES] [nvarchar](200) NOT NULL,
	[REMARK] [nvarchar](200) NOT NULL,
	[HITS] [bigint] NOT NULL,
	[SOURCE] [nvarchar](200) NOT NULL,
	[LINK] [nvarchar](200) NOT NULL,
	[AUTHOR] [nvarchar](50) NOT NULL,
	[ISTOP] [int] NOT NULL, 
	[ISINDEX] [int] NOT NULL, 
	[ORDERNO] [bigint] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_assort](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[NO] [nvarchar](50) NOT NULL,
	[NAME] [nvarchar](20) NOT NULL,
	[DES] [nvarchar](200) NULL,
	[IPLIMIT] [nvarchar](2000) NULL,
	[PARENTID] [nvarchar](32) NOT NULL,
	[SERIAL] [bigint] NOT NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[PATH] [nvarchar](200) NOT NULL,
	[CHILDREN] [int] NOT NULL, 
	[STATE] [int] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_dw](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[DWBH] [nvarchar](10) NOT NULL,
	[DWMC] [nvarchar](100) NOT NULL,
	[CONTENT] [nvarchar](200) NOT NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[PREDWID] [nvarchar](32) NOT NULL,
	[STATE] [int] NOT NULL,
	[ACTIVETIME] [datetime] NULL,
	[PATH] [nvarchar](250) NOT NULL,
	[CHILDREN] [int] NOT NULL,
	[CHILDACTIVETIME] [datetime] NULL,
	[TEMPLATE] [int] NOT NULL,
	[DWALIAS] [nvarchar](100) NOT NULL,
	[STBNOCOUNT] [int] NOT NULL,
	[TEMPLATE_HB] [int] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_dw_assort](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[DWID] [nvarchar](32) NOT NULL,
	[ASSORTID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_log](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[RESOURCEID] [nvarchar](32) NOT NULL,
	[CONTENT] [ntext] NULL,
	[CREATEID] [nvarchar](32) NOT NULL,
	[CREATETIME] [datetime] NULL,
	[CREATEIP] [nvarchar](20) NOT NULL,
	[DWID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_member](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[USERNAME] [nvarchar](200) NOT NULL,
	[PASSWD] [nvarchar](128) NOT NULL,
	[REALNAME] [nvarchar](100) NOT NULL,
	[CONNECT] [nvarchar](200) NOT NULL,
	[EMAIL] [nvarchar](100) NOT NULL,
	[CREATETIME] [datetime] NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[REMARK] [nvarchar](200) NOT NULL,
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_message](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[PARENTID] [nvarchar](32) NOT NULL,
	[ARTICLEID] [nvarchar](32) NOT NULL,
	[TITLE] [nvarchar](200) NOT NULL,
	[CONTENT] [ntext] NULL,
	[WRITER] [nvarchar](100) NOT NULL,
	[PHONE] [nvarchar](100) NOT NULL,
	[MOBILE] [nvarchar](100) NOT NULL,
	[STATE] [int] NOT NULL,
	[CREATETIME] [datetime] NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[CATEGORY] [nvarchar](50) NOT NULL,
	[DWID] [nvarchar](32) NOT NULL,
	[ISOPEN] [int] NOT NULL,
	[ISDELETED] [int] NOT NULL,
	[REPLY] [ntext] NULL,
	[HITS] [bigint] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_notice](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[TITLE] [nvarchar](200) NOT NULL,
	[CONTENT] [ntext] NULL, 
	[STATE] [int] NOT NULL,
	[CREATEID] [nvarchar](32) NOT NULL,
	[CREATETIME] [datetime] NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[SUMMARY] [nvarchar](250) NOT NULL,
	[DWID] [nvarchar](32) NOT NULL,
	[HITS] [bigint] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_operation](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[NAME] [nvarchar](20) NOT NULL,
	[IDENTITY] [nvarchar](50) NOT NULL,
	[SORTNO] [int] NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_privilege](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[RESOURCEID] [nvarchar](32) NOT NULL,
	[OPERATIONID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_resource](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[NAME] [nvarchar](20) NOT NULL,
	[IDENTITY] [nvarchar](100) NOT NULL,
	[CREATETIME] [datetime] NULL,
	[SYSID] [nvarchar](32) NOT NULL,
	[CHILDREN] [int] NOT NULL,
	[PATH] [nvarchar](250) NOT NULL,
	[PARENTID] [nvarchar](32) NOT NULL,
	[EDITUSER] [nvarchar](32) NOT NULL,
	[EDITTIME] [datetime] NULL,
	[COMMENT] [nvarchar](100) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_role](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[NAME] [nvarchar](20) NOT NULL,
	[DES] [nvarchar](200) NOT NULL,
	[STATE] [int] NOT NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL, 
	PRIMARY KEY  (ROW_ID)
);


CREATE TABLE [cms_rolepri](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[ROLEID] [nvarchar](32) NOT NULL,
	[PRIVILEGEID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_user](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[NAME] [nvarchar](20) NOT NULL,
	[CODE] [nvarchar](20) NOT NULL,
	[PASSWD] [nvarchar](100) NOT NULL,
	[EMAIL] [nvarchar](100) NOT NULL,
	[PHONE] [nvarchar](100) NOT NULL,
	[DES] [nvarchar](200) NOT NULL,
	[STATE] [int] NOT NULL,
	[UPDATEID] [nvarchar](32) NOT NULL,
	[UPDATETIME] [datetime] NULL,
	[LOGIN] [bigint] NOT NULL,
	[CREATEID] [nvarchar](32) NOT NULL,
	[CREATTIME] [datetime] NULL,
	[DWID] [nvarchar](32) NOT NULL,
	[LOGINTIME] [datetime] NULL,
	[TIMES] [int] NOT NULL,
	[LOGINIP] [nvarchar](50) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_user_assort](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[USERID] [nvarchar](32) NOT NULL,
	[ASSORTID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_useractive](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[USERID] [nvarchar](32) NULL,
	[USERNAME] [nvarchar](30) NULL,
	[ACTIVETIME] [datetime] NULL,
	[DWID] [nvarchar](32) NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_userrole](
	[ROW_ID] [nvarchar](32) NOT NULL,
	[USERID] [nvarchar](32) NOT NULL,
	[ROLEID] [nvarchar](32) NOT NULL, 
	PRIMARY KEY  (ROW_ID)
);

CREATE TABLE [cms_variable](
	[IDENTITY] [nvarchar](50) NOT NULL,
	[VAL] [ntext] NULL,
);


INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('1', '查看', 'view', 1); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('3', '添加', 'add', 3); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('4', '修改', 'update', 4); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('5', '删除', 'delete', 5); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('6', '审核', 'audit', 6); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('8', '设置', 'setup', 8); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('10', '回复', 'reply', 10); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('9', '批示', 'postil', 9); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('2', '查询', 'search', 2); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('13', '还原', 'restore', 13); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('14', '复制', 'copy', 14); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('15', '发布', 'report', 15); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('16', '退回', 'back', 16); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('17', '回复', 'reply', 17); 
INSERT [cms_operation] ([ROW_ID], [NAME], [IDENTITY], [SORTNO]) VALUES ('18', '排序', 'order', 18); 

INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('00f1280244ca4c36bae92b40eae00d6c', '4e40622bec5241fd9d878e076149f79c', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('01c2ba9201a94d91a6c96817b4c124e7', '9ae25f7ea1cf44eaa25036a66e0bf131', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('02bbae4e22c64eebac4d04add5aed1f3', 'f553f0a0aef4439d90818b9c44f6367d', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('081aae34edda498a8081d542312bebd9', '8379f3c71547434e927d63181a6e7137', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('096a375443f641638aec821fb3bd51b0', '022e31e9f1134a5ca1af2abdfb8065e9', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('0dd555a9d5a340f28d4a37b76c5c4b81', 'd61712e23bac40a7b0da103c17f2e072', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('10dfe625a74d4131918013a66a6405e6', 'c53405ba38244f529515fe4bb1b96a7b', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('14284c682df64aed9bcaaab268debfd9', '8379f3c71547434e927d63181a6e7137', '10')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('14a731804cd34b3ea923f4e641c9179c', '01301550c2564c14a507adc2a75e5007', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('15820503da304ce3bd661d88f645ed17', 'b3ae04f8727449949325a3d6e77771d0', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('17dade74081f415db361fc94c2bd8bec', '9d9463ac0fec4cd29eb81806464195b9', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('1890ac344ee54312951235bd9dce43f3', '0f0cec4345884fd1996508a141c2d73c', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('18b8c00a09ff4ab39352da3562693e9d', '9d9463ac0fec4cd29eb81806464195b9', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('18de9fb3c5934c26a7ca72da1d2bbe2c', 'd61712e23bac40a7b0da103c17f2e072', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('1ed935c9fc71459589062f5dd063bd70', 'ff35c1fbed1a4e4aab8ed53162993e2b', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2004d1f6327c479fae471a4f8d890b3d', '453963e656284e85a1ceee080b4fa529', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('200c258410784957b140f14875bcd1a7', '8dcc5d34750d4d359480425d13c5d760', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('203b633107014db1b422ce40dbb8aa34', '453963e656284e85a1ceee080b4fa529', '13')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2241cf4df0c94fdea6ad0a17f48ce6ea', '6feca7d9680b4ec5b9f6723e1695d9a5', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2321fce09869418fbdcdecffc0154750', 'fe1c05ac952c412aa8b577396b96edf5', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('284aea685eb7429997dab0a0f91d0d0c', '8dcc5d34750d4d359480425d13c5d760', '16')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('285342ea6d054aa8adca503c799f561d', 'c53405ba38244f529515fe4bb1b96a7b', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2bb8371a4da6456dbcf0bfcc7dc1e449', '8379f3c71547434e927d63181a6e7137', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2d7d2a3b40e54efe8afb57d431013b01', '4e40622bec5241fd9d878e076149f79c', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2da553303e934d6597075918a462d056', 'ab204c8692704e3298ae893ad7c78a6a', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2f165deb07324995a31a133d0c3395f5', '6feca7d9680b4ec5b9f6723e1695d9a5', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2fa12d1dc46c42c29dd5c20f8a6cbb9a', 'c53405ba38244f529515fe4bb1b96a7b', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('2fb3040d65bc40c492888093aebc2d35', '8379f3c71547434e927d63181a6e7137', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('30646d6c7c534de48b10b40181ec61c9', '9ae25f7ea1cf44eaa25036a66e0bf131', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('32e0b981eec9452280b66e4648e31948', '02a2608fa68848c78e08f3395c565555', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('36e0aa3fbbd8471c97fd9ad0cb5e13c5', '42225b0c4cba48ba8f1472dd69ad6245', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('426d2e8fe0fe4613aca8d2539db5bbff', '4e40622bec5241fd9d878e076149f79c', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('42a631fee9cc465484a1af9da2b094ae', '5e2b03024339434385e50b1947baa070', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('43abd33dde83442d9ef0d6ed0668e22b', '8f82702014494a4ba8c23299a8554fec', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('45d4d9c3057f456d98c3eab718df1769', 'be8cb65ac7534f95be8a5eb635064f2e', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('48308251ce624eaebcdd4ccce2301375', '6c6bc932d8074503bfb4de75cfa4503c', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('4e05556478c94685a495bdfa28a27915', '8dcc5d34750d4d359480425d13c5d760', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('4e4e8fd268dc44b5aeb2a0d19ddfdeb6', '6feca7d9680b4ec5b9f6723e1695d9a5', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('4e91035f6b3f41a59740de1b74933985', '5e89cce254dd4b70b66ce029694f827e', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('4f732e0dc8bb4541a568e4f512c625eb', '8dcc5d34750d4d359480425d13c5d760', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('4fe6628897564fa4a93e4a94ca70e4ce', '4e40622bec5241fd9d878e076149f79c', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('5035c49f69644c5d8fde1af22f615d9d', '291fd69816de4362a4262b727e5553f4', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('517b1851c8974a11a844b734f8ea7bd4', '0f0cec4345884fd1996508a141c2d73c', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('5533094c92aa4e3c801f181f9be23ee1', 'fe1c05ac952c412aa8b577396b96edf5', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('56a97061cbd4402d91c37d0d5fad9572', '25c058c54d0b417c8412376696051ffd', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('5e38ca10515048f9b502e4cef8b26c44', '9baf5cfda18f4b42836857f2e5097c73', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('5e483c7c626b4364a85bf0ef0ae6aa42', '022e31e9f1134a5ca1af2abdfb8065e9', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('622aec9560c0424b99fac7c3170e76d6', '91df2329d3d042548961a28a3be5160a', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('62a530ee9b994188ae443899bc0da167', '5e89cce254dd4b70b66ce029694f827e', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('62e842a78193404fb217389fa1728e9e', '91df2329d3d042548961a28a3be5160a', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('674cc9e6d84344d79787d0fe7a0f13e2', '9ae25f7ea1cf44eaa25036a66e0bf131', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('682c9ecbb1834298aa6ce154b6e82bb6', '6c6bc932d8074503bfb4de75cfa4503c', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('68c2a608b3a941f49123f2d51290cb2b', '01301550c2564c14a507adc2a75e5007', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('6b93b45f40424494b8714b6ac9ccf758', '453963e656284e85a1ceee080b4fa529', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('6c5ec58daaf84b479970b2351a2a7369', '861d134cf1f041beace2406875e6aada', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('6d883930be1641d4b9a2713a4ec56447', '89921d9180a2434b98ad3d2d03a177a6', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('720c056805414dffa9bc46860d2672da', '0f352f97bd9245348e6f8964174bfe05', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('737a19eb1de1440bab5dfda2769b4c4b', '9d9463ac0fec4cd29eb81806464195b9', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('74863c9e72834f98bbb152a8d57f0450', '8379f3c71547434e927d63181a6e7137', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('76232a60dd5e4369b7751e09b30ef121', '01301550c2564c14a507adc2a75e5007', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('76eb781ddeb94a38aa25090e32f47aa0', '9baf5cfda18f4b42836857f2e5097c73', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('7a92f4bbd7724f7ea7daf35ac2970ebf', '291fd69816de4362a4262b727e5553f4', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('7d2bbd7684164447af1170f9a688b1ad', '9ae25f7ea1cf44eaa25036a66e0bf131', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('816cd43d63a54abc9ff382b3a1f2f272', '9d9463ac0fec4cd29eb81806464195b9', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('853eb5ebf459446b9fd36272c995e42d', '8379f3c71547434e927d63181a6e7137', '16')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('85b18580ec7b4e65b3fc3a4541c799d4', '6c6bc932d8074503bfb4de75cfa4503c', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('862653c27b604607af948c7896af7f64', 'd61712e23bac40a7b0da103c17f2e072', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('88016ba6bb3f4652b6aeb68d20390861', '42225b0c4cba48ba8f1472dd69ad6245', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('8a46a0d57322446bbeeceafa5afceb6b', '5e89cce254dd4b70b66ce029694f827e', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('8a6278b0c4e24ab68ef13d44c7e5b44b', '861d134cf1f041beace2406875e6aada', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('8fb28d2b5dfc4e339160736dd6d9f6ee', '5e2b03024339434385e50b1947baa070', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('91da09a2751942b0beab08bda305c9e5', '31796c8ad25a482a84dd47e22a6409d1', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('99db0e42ba874ad0a80677597e0ba87a', '91df2329d3d042548961a28a3be5160a', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('9ec33b86fc2a43d799eb4e61f9fc75f7', '8f82702014494a4ba8c23299a8554fec', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('9fac8ca5cbfc478795b6a533bea00bff', '8f82702014494a4ba8c23299a8554fec', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a04c70445ed241e7aed2a6530f3401c7', '22019cbadb7a45a6bf963f9ef2ffd184', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a07277b1ad0f4ff1ae16c9525d2db6a1', 'c53405ba38244f529515fe4bb1b96a7b', '6')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a384773a82024076932fd2a96a10be1a', '25c058c54d0b417c8412376696051ffd', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a51ca3bf927841dab559c693beb02a67', '5e2b03024339434385e50b1947baa070', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a667504481fb4f7fad326edc81a6dc34', 'ab204c8692704e3298ae893ad7c78a6a', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a70f77e82ebf4236a6d6a8db6e389a83', 'f553f0a0aef4439d90818b9c44f6367d', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a75a65a6b58a45869bb81d8eb46e48ed', '8dcc5d34750d4d359480425d13c5d760', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('aa1da01788d2410c932f382f66d7b9be', '89921d9180a2434b98ad3d2d03a177a6', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('ab952c459791426bb98810f83944af59', '31796c8ad25a482a84dd47e22a6409d1', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('adfbe47d65144e02a90f99121d35f1d6', '0f0cec4345884fd1996508a141c2d73c', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('ae4a96c05f3e40b58189fe155d81e123', 'b3ae04f8727449949325a3d6e77771d0', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b1267a73c3964c9897b90b5d505eb505', '9dd18ae2ef1b4dc29f8025b45145f5c9', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b387b115a6c04f46962d8e914914ae07', '8379f3c71547434e927d63181a6e7137', '15')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b4538e4af70546b690b8cc12b0f2cda0', '291fd69816de4362a4262b727e5553f4', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b45e5303ba0d4a84b3f889ace7682f95', 'ff35c1fbed1a4e4aab8ed53162993e2b', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b793b95bd92147eb9e42eb274dd25d32', '022e31e9f1134a5ca1af2abdfb8065e9', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('b941a74427c54a48b65fe0a197f9c9e0', '31796c8ad25a482a84dd47e22a6409d1', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('bb5bc48b4d534c23b4c2b14f12361a25', '0f0cec4345884fd1996508a141c2d73c', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('bbb0ff859830492da4043e3f46eeb232', '02a2608fa68848c78e08f3395c565555', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('bc26d58ff0f24c278da3baa2a9606909', '8dcc5d34750d4d359480425d13c5d760', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('beb42fdc46c74aab8bcf0345b5c0e908', '6feca7d9680b4ec5b9f6723e1695d9a5', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c033396876d2441e89cd4a5eeb0cc80c', '9ae25f7ea1cf44eaa25036a66e0bf131', '10')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c24e1199d44041aa8ec509daab688a4b', '8379f3c71547434e927d63181a6e7137', '13')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c2b01ea60d3d4612ae6a3cdf6bb086fc', '9baf5cfda18f4b42836857f2e5097c73', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c30fc056aaf74ae3965f292af0042ca8', '8379f3c71547434e927d63181a6e7137', '6')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c6ad9850fe7a47c4834643068b6b3b28', 'b3ae04f8727449949325a3d6e77771d0', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c7c8229b695a4cd780974a8a9d4281e0', 'c53405ba38244f529515fe4bb1b96a7b', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c80f04bc52a24d3e8dfbf0aed5d40349', '291fd69816de4362a4262b727e5553f4', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('c8e9debcc5664f33be932ee62a559497', '9dd18ae2ef1b4dc29f8025b45145f5c9', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('cb88caea75f84c5599ea86c91a9d33c5', '3022b187dfde4be6a64fa0e961125bc7', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('cc028a4e70c44e35b0e2df67d8ddea6e', '4e40622bec5241fd9d878e076149f79c', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('ccad3695da964bbaa0e53595f514985a', '31796c8ad25a482a84dd47e22a6409d1', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('d333441d87b5442d8ad718b31b384642', '453963e656284e85a1ceee080b4fa529', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('d50f7bcac4a64342a744e2f76fcbd946', '861d134cf1f041beace2406875e6aada', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('d79b7d31a43f4a169cf502ff52dd3f4d', '91df2329d3d042548961a28a3be5160a', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('da970e9c3c9445349eb0566da1359c70', '01301550c2564c14a507adc2a75e5007', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('de738f0e2420413f84a00278c93c150e', '6c6bc932d8074503bfb4de75cfa4503c', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('df4d1210369c42aaadeb6c9dc60d5d3d', '5e2b03024339434385e50b1947baa070', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('df5ac44d905941808e300f725738d450', '5ba1dede632240428a7c6b09d070e6b5', '8')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('df8046432e4d4ce7a6cf7c4af6123ecb', 'b3ae04f8727449949325a3d6e77771d0', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('e6c92e1fd41245649b5f91954de45cf4', '9d9463ac0fec4cd29eb81806464195b9', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('e70b5436f88a48f8ac2fd3743f286153', '1759f3ed11c44f899aa059190dab6647', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('e77cd48a0498446e9c89f64ce95adb8a', '9ae25f7ea1cf44eaa25036a66e0bf131', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('e9a132c01a11497291a8301d38eaaa1f', 'c53405ba38244f529515fe4bb1b96a7b', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('e9ddbfc98c034e75a6499ffb992fc700', '22019cbadb7a45a6bf963f9ef2ffd184', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('ee0391be728343a7b38b85e17f39e01d', '791f75a3541a4d808973c3b6b07ee607', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f411d6d2fd0a413b8dd303d28d1d88ff', 'd61712e23bac40a7b0da103c17f2e072', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f4a4cf0a0367460fafee0b5c0f8f1f08', '022e31e9f1134a5ca1af2abdfb8065e9', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f4d893bd497245299af3a8880e435544', '5ba1dede632240428a7c6b09d070e6b5', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f4f5d09a19d4487489306f8fec5d49a9', '022e31e9f1134a5ca1af2abdfb8065e9', '6')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f5cff47b728e4ba3bcd4d36813996bc3', '6feca7d9680b4ec5b9f6723e1695d9a5', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('f879e500f5fb410dbb2d6bdcbc7064b1', '291fd69816de4362a4262b727e5553f4', '4')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('faa17a5df6074101bad388dc08636a40', 'd61712e23bac40a7b0da103c17f2e072', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('fb36cd7579a94f2d81730c41944d4dd8', '022e31e9f1134a5ca1af2abdfb8065e9', '3')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('fb4bbfd89512448bb6db9236d6782f28', '8379f3c71547434e927d63181a6e7137', '2')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('fbc9ec03c6cb49f3bff66ecf948e14e1', '9baf5cfda18f4b42836857f2e5097c73', '1')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('feb352123a434826993e03a232763ff9', '01301550c2564c14a507adc2a75e5007', '5')
INSERT [cms_privilege] ([ROW_ID], [RESOURCEID], [OPERATIONID]) VALUES ('a625074f4396468f9c1742f4ecc9bf29', '9edbaee7c9a14fa8971cd7ccb268728e', '8');

INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('022e31e9f1134a5ca1af2abdfb8065e9', '待审核文章', '1004', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,022e31e9f1134a5ca1af2abdfb8065e9,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('02a2608fa68848c78e08f3395c565555', '文章统计', '1002', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,02a2608fa68848c78e08f3395c565555,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('0f352f97bd9245348e6f8964174bfe05', '系统管理', '40', NULL, '', 3, '0f352f97bd9245348e6f8964174bfe05,', '0', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('1759f3ed11c44f899aa059190dab6647', '用户管理', '30', NULL, '', 4, '1759f3ed11c44f899aa059190dab6647,', '0', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('25c058c54d0b417c8412376696051ffd', '快速发布', '1003', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,25c058c54d0b417c8412376696051ffd,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('291fd69816de4362a4262b727e5553f4', '角色', '3003', NULL, '', 0, '1759f3ed11c44f899aa059190dab6647,291fd69816de4362a4262b727e5553f4,', '1759f3ed11c44f899aa059190dab6647', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('31796c8ad25a482a84dd47e22a6409d1', '用户', '300202', NULL, '', 0, '1759f3ed11c44f899aa059190dab6647,4e40622bec5241fd9d878e076149f79c,31796c8ad25a482a84dd47e22a6409d1,', '4e40622bec5241fd9d878e076149f79c', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('453963e656284e85a1ceee080b4fa529', '回收站', '1008', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,453963e656284e85a1ceee080b4fa529,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('4e40622bec5241fd9d878e076149f79c', '单位', '3002', NULL, '', 2, '1759f3ed11c44f899aa059190dab6647,4e40622bec5241fd9d878e076149f79c,', '1759f3ed11c44f899aa059190dab6647', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('5ba1dede632240428a7c6b09d070e6b5', '分类', '300201', NULL, '', 0, '1759f3ed11c44f899aa059190dab6647,4e40622bec5241fd9d878e076149f79c,5ba1dede632240428a7c6b09d070e6b5,', '4e40622bec5241fd9d878e076149f79c', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('5e89cce254dd4b70b66ce029694f827e', '草稿箱', '1009', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,5e89cce254dd4b70b66ce029694f827e,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('6c6bc932d8074503bfb4de75cfa4503c', '权限', '3004', NULL, '', 0, '1759f3ed11c44f899aa059190dab6647,6c6bc932d8074503bfb4de75cfa4503c,', '1759f3ed11c44f899aa059190dab6647', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('791f75a3541a4d808973c3b6b07ee607', '插件功能', '20', NULL, '', 1, '791f75a3541a4d808973c3b6b07ee607,', '0', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('89921d9180a2434b98ad3d2d03a177a6', '个人信息', '3001', NULL, '', 0, '1759f3ed11c44f899aa059190dab6647,89921d9180a2434b98ad3d2d03a177a6,', '1759f3ed11c44f899aa059190dab6647', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('8dcc5d34750d4d359480425d13c5d760', '已审核文章', '1006', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,8dcc5d34750d4d359480425d13c5d760,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('8f82702014494a4ba8c23299a8554fec', '日志', '4002', NULL, '', 0, '0f352f97bd9245348e6f8964174bfe05,8f82702014494a4ba8c23299a8554fec,', '0f352f97bd9245348e6f8964174bfe05', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('9ae25f7ea1cf44eaa25036a66e0bf131', '留言板', '2001', NULL, '', 0, '791f75a3541a4d808973c3b6b07ee607,9ae25f7ea1cf44eaa25036a66e0bf131,', '791f75a3541a4d808973c3b6b07ee607', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('9baf5cfda18f4b42836857f2e5097c73', '文章分类', '4003', NULL, '', 0, '0f352f97bd9245348e6f8964174bfe05,9baf5cfda18f4b42836857f2e5097c73,', '0f352f97bd9245348e6f8964174bfe05', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('9d9463ac0fec4cd29eb81806464195b9', '通知公告', '1001', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,9d9463ac0fec4cd29eb81806464195b9,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('be8cb65ac7534f95be8a5eb635064f2e', '信息发布', '10', NULL, '', 9, 'be8cb65ac7534f95be8a5eb635064f2e,', '0', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('c53405ba38244f529515fe4bb1b96a7b', '未通过文章', '1005', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,c53405ba38244f529515fe4bb1b96a7b,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('d61712e23bac40a7b0da103c17f2e072', '用户', '2002', NULL, '', 0, '791f75a3541a4d808973c3b6b07ee607,d61712e23bac40a7b0da103c17f2e072,', '791f75a3541a4d808973c3b6b07ee607', '1', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('fe1c05ac952c412aa8b577396b96edf5', '共享文章', '1007', NULL, '', 0, 'be8cb65ac7534f95be8a5eb635064f2e,fe1c05ac952c412aa8b577396b96edf5,', 'be8cb65ac7534f95be8a5eb635064f2e', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('ff35c1fbed1a4e4aab8ed53162993e2b', '系统参数', '4001', NULL, '', 0, '0f352f97bd9245348e6f8964174bfe05,ff35c1fbed1a4e4aab8ed53162993e2b,', '0f352f97bd9245348e6f8964174bfe05', '', NULL, '')
INSERT [cms_resource] ([ROW_ID], [NAME], [IDENTITY], [CREATETIME], [SYSID], [CHILDREN], [PATH], [PARENTID], [EDITUSER], [EDITTIME], [COMMENT]) VALUES ('9edbaee7c9a14fa8971cd7ccb268728e', 'IP限制', '1010', NULL, '', '0', 'be8cb65ac7534f95be8a5eb635064f2e,9edbaee7c9a14fa8971cd7ccb268728e,', 'be8cb65ac7534f95be8a5eb635064f2e', '', null, '');

INSERT [cms_role] ([ROW_ID], [NAME], [DES], [STATE], [UPDATEID], [UPDATETIME]) VALUES ('4640f8c6fe5248c38adcfaa01a55babb', '文章发布员', '', 0, '0', NULL)
INSERT [cms_role] ([ROW_ID], [NAME], [DES], [STATE], [UPDATEID], [UPDATETIME]) VALUES ('5adaf0ad9ad54703a975c536a94202e3', '站点管理员', '', 0, '0', NULL)
INSERT [cms_role] ([ROW_ID], [NAME], [DES], [STATE], [UPDATEID], [UPDATETIME]) VALUES ('b9d8dc92128e46bca71757d31cbc8aff', '文章审核员', '', 0, '0', NULL)

INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('01d88d33ec0e4c22a95d46f528db60a1', '5adaf0ad9ad54703a975c536a94202e3', 'c80f04bc52a24d3e8dfbf0aed5d40349')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('0355242338f9482b9125473407db3579', 'b9d8dc92128e46bca71757d31cbc8aff', '10dfe625a74d4131918013a66a6405e6')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('0399d72dd0cf49e5b7e70b5bebf2daa4', '4640f8c6fe5248c38adcfaa01a55babb', '4f732e0dc8bb4541a568e4f512c625eb')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('03c0d4c06ed24248a2a9ef8d2df0b97d', '4640f8c6fe5248c38adcfaa01a55babb', '6b93b45f40424494b8714b6ac9ccf758')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('03e1ec6b1397401a853f4a9f4a03139f', '5adaf0ad9ad54703a975c536a94202e3', '32e0b981eec9452280b66e4648e31948')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('05c944d3e13949fc8b49d80a13b4b140', '5adaf0ad9ad54703a975c536a94202e3', 'b941a74427c54a48b65fe0a197f9c9e0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('06e7e51ddb754bbca17eb95147740709', '5adaf0ad9ad54703a975c536a94202e3', '01c2ba9201a94d91a6c96817b4c124e7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('07ec749c2de04f9183dd95fef4e2c97b', 'b9d8dc92128e46bca71757d31cbc8aff', 'f4f5d09a19d4487489306f8fec5d49a9')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('080730c5f0a54bccaebd83ef28043608', 'b9d8dc92128e46bca71757d31cbc8aff', 'bc26d58ff0f24c278da3baa2a9606909')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('0ca30dfc255d44cdb1afc270802eed6f', '4640f8c6fe5248c38adcfaa01a55babb', 'a384773a82024076932fd2a96a10be1a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1189d920a805433fb13aa5ec1baefcaf', 'b9d8dc92128e46bca71757d31cbc8aff', '203b633107014db1b422ce40dbb8aa34')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('131b01050d2a48039c8cca5330542646', '5adaf0ad9ad54703a975c536a94202e3', '4e05556478c94685a495bdfa28a27915')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('162af821d52145b884117dfcb420336d', 'b9d8dc92128e46bca71757d31cbc8aff', '816cd43d63a54abc9ff382b3a1f2f272')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('16430430d553480d9416a4353832fd7a', '4640f8c6fe5248c38adcfaa01a55babb', 'aa1da01788d2410c932f382f66d7b9be')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1976181af92f4972aaa52263bd2b20b9', '5adaf0ad9ad54703a975c536a94202e3', '7d2bbd7684164447af1170f9a688b1ad')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1a05d1270c924e05bf6f8e15f7d4acc6', '4640f8c6fe5248c38adcfaa01a55babb', 'bbb0ff859830492da4043e3f46eeb232')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1a6ea6027b9b41408e36d2f162c2c1f0', '5adaf0ad9ad54703a975c536a94202e3', '91da09a2751942b0beab08bda305c9e5')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1c5aac156b9e4aa6ad9fdb06d3bfea26', '5adaf0ad9ad54703a975c536a94202e3', 'f879e500f5fb410dbb2d6bdcbc7064b1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1ce8822a0e884425a445968bd93fa786', '5adaf0ad9ad54703a975c536a94202e3', 'cc028a4e70c44e35b0e2df67d8ddea6e')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('1d43e2f036884ffd87a1b42de1925c26', 'b9d8dc92128e46bca71757d31cbc8aff', '1ed935c9fc71459589062f5dd063bd70')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('213f580b044e46bf970adb349e42759f', 'b9d8dc92128e46bca71757d31cbc8aff', '18b8c00a09ff4ab39352da3562693e9d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('2243b3e3028f444db589f8785b107fba', '4640f8c6fe5248c38adcfaa01a55babb', 'e9a132c01a11497291a8301d38eaaa1f')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('23c0600deb764dbbb42cde00433cc1f1', '5adaf0ad9ad54703a975c536a94202e3', '30646d6c7c534de48b10b40181ec61c9')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('26b01cca4f344d5280c02e897c829db0', '5adaf0ad9ad54703a975c536a94202e3', '18de9fb3c5934c26a7ca72da1d2bbe2c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('2a9fa20deb13435799771bf80d3ceab2', '4640f8c6fe5248c38adcfaa01a55babb', '2fa12d1dc46c42c29dd5c20f8a6cbb9a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('2e32a236e4fe41afa5bdce83fb63e5da', '4640f8c6fe5248c38adcfaa01a55babb', '62a530ee9b994188ae443899bc0da167')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('2ed15e0144654d6a9c5cdf144504d15e', '4640f8c6fe5248c38adcfaa01a55babb', 'b45e5303ba0d4a84b3f889ace7682f95')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('3093501c381e493f97df12a16b8aa7ee', '5adaf0ad9ad54703a975c536a94202e3', '720c056805414dffa9bc46860d2672da')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('31eea416761d4f95a00a58955c61d434', '5adaf0ad9ad54703a975c536a94202e3', 'c2b01ea60d3d4612ae6a3cdf6bb086fc')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('32a6a9543c504823aa72c7dc83b8f88f', '4640f8c6fe5248c38adcfaa01a55babb', '10dfe625a74d4131918013a66a6405e6')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('32e0ebd75e7249a7be05fc30fc8046b4', '5adaf0ad9ad54703a975c536a94202e3', '00f1280244ca4c36bae92b40eae00d6c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('353f9ebf50d24dce95b34ad80413386d', '5adaf0ad9ad54703a975c536a94202e3', 'e6c92e1fd41245649b5f91954de45cf4')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('366c74bde21044e4890a26896c07b20f', 'b9d8dc92128e46bca71757d31cbc8aff', '720c056805414dffa9bc46860d2672da')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('3a9f20a8bca24a669b181b90b78fc0d0', 'b9d8dc92128e46bca71757d31cbc8aff', '45d4d9c3057f456d98c3eab718df1769')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('3f088cb7b90741aaa71770e6da18df82', '5adaf0ad9ad54703a975c536a94202e3', 'ab952c459791426bb98810f83944af59')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('401b434b549e45c48f5868b3d228d947', 'b9d8dc92128e46bca71757d31cbc8aff', '4f732e0dc8bb4541a568e4f512c625eb')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('407127d0c476427dad989e1a4f69f9f4', '5adaf0ad9ad54703a975c536a94202e3', '0dd555a9d5a340f28d4a37b76c5c4b81')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('43de3b4815e5467ea884e5f8b63fb8b8', 'b9d8dc92128e46bca71757d31cbc8aff', '9ec33b86fc2a43d799eb4e61f9fc75f7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4501761f68d645f6a801127af7a7d2f8', '4640f8c6fe5248c38adcfaa01a55babb', 'bc26d58ff0f24c278da3baa2a9606909')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('47f181ea9a244794be35c65e413dc32e', '5adaf0ad9ad54703a975c536a94202e3', '4fe6628897564fa4a93e4a94ca70e4ce')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4897e3ed9c2443a6ba9bf4d657924f53', '5adaf0ad9ad54703a975c536a94202e3', '674cc9e6d84344d79787d0fe7a0f13e2')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('49720bfe43c64905a6aaa3d811c8ecbd', '5adaf0ad9ad54703a975c536a94202e3', 'f4a4cf0a0367460fafee0b5c0f8f1f08')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4a0035e307364e40b8902aa2d0ae3875', '4640f8c6fe5248c38adcfaa01a55babb', '8a46a0d57322446bbeeceafa5afceb6b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4bae65640dd0464dbf4c0d0e679c16fe', '5adaf0ad9ad54703a975c536a94202e3', 'bc26d58ff0f24c278da3baa2a9606909')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4d1d45e7540c49ce88884292270a04e1', '5adaf0ad9ad54703a975c536a94202e3', '9ec33b86fc2a43d799eb4e61f9fc75f7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4e65c21998b946d3bb3c41c9f7bb1062', '5adaf0ad9ad54703a975c536a94202e3', 'de738f0e2420413f84a00278c93c150e')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4ef3d10157fa4e42b392c553ea40fcae', '4640f8c6fe5248c38adcfaa01a55babb', 'b793b95bd92147eb9e42eb274dd25d32')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('4f9202ad0aac492895433fb742e33a91', '5adaf0ad9ad54703a975c536a94202e3', 'a75a65a6b58a45869bb81d8eb46e48ed')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('50b1988eaf7c4451ba0176e78f13665d', 'b9d8dc92128e46bca71757d31cbc8aff', 'b793b95bd92147eb9e42eb274dd25d32')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5248dea657d64b688f1fbaa1afd6f5a8', '5adaf0ad9ad54703a975c536a94202e3', '5e483c7c626b4364a85bf0ef0ae6aa42')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('53b78ab7f95449cf8b250634f34e4730', 'b9d8dc92128e46bca71757d31cbc8aff', 'fbc9ec03c6cb49f3bff66ecf948e14e1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('54027cf2ac7f4e1b8512dbd416f8cd3f', 'b9d8dc92128e46bca71757d31cbc8aff', '7d2bbd7684164447af1170f9a688b1ad')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('54c28a5976b34c338026813c24a73364', '5adaf0ad9ad54703a975c536a94202e3', 'fb36cd7579a94f2d81730c41944d4dd8')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5500d4e907b84fac987f4c81e76b4e6f', 'b9d8dc92128e46bca71757d31cbc8aff', 'a384773a82024076932fd2a96a10be1a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('577c16f9c06348568be6e5d8eff5f2a6', '5adaf0ad9ad54703a975c536a94202e3', 'bbb0ff859830492da4043e3f46eeb232')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5798557f3e554935ab657120e64a749e', '4640f8c6fe5248c38adcfaa01a55babb', 'c7c8229b695a4cd780974a8a9d4281e0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('57a34ef3b39d491eb9339d703e3e2759', '5adaf0ad9ad54703a975c536a94202e3', 'c033396876d2441e89cd4a5eeb0cc80c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5842ed57bd924f1d8dee8fec06a3e8c3', '5adaf0ad9ad54703a975c536a94202e3', '816cd43d63a54abc9ff382b3a1f2f272')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('591ce50b1f0b41da91fdf440527b01e8', 'b9d8dc92128e46bca71757d31cbc8aff', 'f4a4cf0a0367460fafee0b5c0f8f1f08')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5c2e654f3d414a6baf0f96cb7fc476b3', '5adaf0ad9ad54703a975c536a94202e3', '9fac8ca5cbfc478795b6a533bea00bff')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5d0992c5cbf143a2a44542e7f7d62951', '5adaf0ad9ad54703a975c536a94202e3', 'e77cd48a0498446e9c89f64ce95adb8a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5d1badd318654bb6b2fe5f2a4ac4cf22', 'b9d8dc92128e46bca71757d31cbc8aff', '4e91035f6b3f41a59740de1b74933985')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5d6f3491abe04f4582616ddd2c4b718d', '5adaf0ad9ad54703a975c536a94202e3', 'ccad3695da964bbaa0e53595f514985a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('5e7c7efcc8b24ae096bc6259b19e9fe8', '5adaf0ad9ad54703a975c536a94202e3', 'b4538e4af70546b690b8cc12b0f2cda0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('602afb208c5b43e2a1832ade64c02f7d', 'b9d8dc92128e46bca71757d31cbc8aff', '285342ea6d054aa8adca503c799f561d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('63ee399f8a09442398a1a5e50d529375', '5adaf0ad9ad54703a975c536a94202e3', '48308251ce624eaebcdd4ccce2301375')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6456ee5375e44daf993e66298288b0e6', '5adaf0ad9ad54703a975c536a94202e3', 'f4d893bd497245299af3a8880e435544')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('657d06cb301c43a9b6c2a7c45c29d09e', '5adaf0ad9ad54703a975c536a94202e3', '200c258410784957b140f14875bcd1a7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('661ed222dae24bcf88de9b36f0adbf57', '5adaf0ad9ad54703a975c536a94202e3', '2d7d2a3b40e54efe8afb57d431013b01')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('66a366f05a3d42ca8fc8d4c8ba90082a', '5adaf0ad9ad54703a975c536a94202e3', 'aa1da01788d2410c932f382f66d7b9be')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('671d4f31503c4ae599121e27f8896a40', 'b9d8dc92128e46bca71757d31cbc8aff', 'df5ac44d905941808e300f725738d450')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('697b7d25b6ca4bb8a81f1d240f26a28c', '5adaf0ad9ad54703a975c536a94202e3', '56a97061cbd4402d91c37d0d5fad9572')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6b44c1dbfc964f4cabe219bf39954f50', '4640f8c6fe5248c38adcfaa01a55babb', '203b633107014db1b422ce40dbb8aa34')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6cd7842c6fa24844ae093f5dbb626749', 'b9d8dc92128e46bca71757d31cbc8aff', 'e9a132c01a11497291a8301d38eaaa1f')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6d318d6aab434ec7bdbf496b44acdf18', 'b9d8dc92128e46bca71757d31cbc8aff', 'e77cd48a0498446e9c89f64ce95adb8a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6e142296b7264689a67d43b31ee1dbe5', '5adaf0ad9ad54703a975c536a94202e3', '426d2e8fe0fe4613aca8d2539db5bbff')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('6fb71eb317774c23a949258e70db9d2b', '5adaf0ad9ad54703a975c536a94202e3', '284aea685eb7429997dab0a0f91d0d0c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('70476ecfcd6446b180172629c4a145f6', '5adaf0ad9ad54703a975c536a94202e3', '5035c49f69644c5d8fde1af22f615d9d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('70837ce23cbd4039a3bf61780d7c487d', '5adaf0ad9ad54703a975c536a94202e3', '285342ea6d054aa8adca503c799f561d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('721a943604014cdfbe816c9b77ed6974', '5adaf0ad9ad54703a975c536a94202e3', '2fa12d1dc46c42c29dd5c20f8a6cbb9a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('76b198562b8f4c55933a35c93cbfd228', '5adaf0ad9ad54703a975c536a94202e3', 'a384773a82024076932fd2a96a10be1a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('78498a31656d4b0bb6f77608f2a27c23', 'b9d8dc92128e46bca71757d31cbc8aff', 'b45e5303ba0d4a84b3f889ace7682f95')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('796e111eda944b02a4d1660ec731806d', 'b9d8dc92128e46bca71757d31cbc8aff', '200c258410784957b140f14875bcd1a7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('7a96aa70c37544a2872d5f9ffa073a53', '5adaf0ad9ad54703a975c536a94202e3', '862653c27b604607af948c7896af7f64')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('7eeca353e4cf4328b98806d7ec2cda38', '5adaf0ad9ad54703a975c536a94202e3', '6d883930be1641d4b9a2713a4ec56447')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('7f39ac2b03c04acdb97607d0393432d9', '5adaf0ad9ad54703a975c536a94202e3', '5e38ca10515048f9b502e4cef8b26c44')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('7f7ff42cf93d4cbda2a715a26cc641d8', '4640f8c6fe5248c38adcfaa01a55babb', 'e70b5436f88a48f8ac2fd3743f286153')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('7ff81eeb05b74c3f8877dbec2d86cf4b', '5adaf0ad9ad54703a975c536a94202e3', '1ed935c9fc71459589062f5dd063bd70')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('82c0ffbe7ff2428dac8558562969a311', 'b9d8dc92128e46bca71757d31cbc8aff', 'bbb0ff859830492da4043e3f46eeb232')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('841a63c6dc0b411180af8c8426fccef3', 'b9d8dc92128e46bca71757d31cbc8aff', '32e0b981eec9452280b66e4648e31948')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8431542572854ab8ae118442082554bc', 'b9d8dc92128e46bca71757d31cbc8aff', '5533094c92aa4e3c801f181f9be23ee1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('853ef3379b504e1fb9db514b9c08c582', '4640f8c6fe5248c38adcfaa01a55babb', 'f4a4cf0a0367460fafee0b5c0f8f1f08')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('857388653f58456fb7cb3374779f31a3', '4640f8c6fe5248c38adcfaa01a55babb', '01c2ba9201a94d91a6c96817b4c124e7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('883391cefee64a4b9b3124f511d2e0c4', '5adaf0ad9ad54703a975c536a94202e3', 'faa17a5df6074101bad388dc08636a40')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('88fb770a26d747e89519cb191a56d4b7', 'b9d8dc92128e46bca71757d31cbc8aff', '4e05556478c94685a495bdfa28a27915')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('891daec214404e2c91b905ef6c741eba', '4640f8c6fe5248c38adcfaa01a55babb', '6d883930be1641d4b9a2713a4ec56447')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('899badc096ab4d65b24bbec495d9f700', 'b9d8dc92128e46bca71757d31cbc8aff', '2004d1f6327c479fae471a4f8d890b3d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8a7f87020e30451d9d4f9aa89166eeb7', '4640f8c6fe5248c38adcfaa01a55babb', '200c258410784957b140f14875bcd1a7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8b8c6e4d0c5c4f43846cf3de6933d229', 'b9d8dc92128e46bca71757d31cbc8aff', '737a19eb1de1440bab5dfda2769b4c4b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8bcd681661e2498ea6ad1ce4729ebff4', 'b9d8dc92128e46bca71757d31cbc8aff', 'fb36cd7579a94f2d81730c41944d4dd8')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8cb73ba059884fa6af7dd0e093295599', '5adaf0ad9ad54703a975c536a94202e3', 'fbc9ec03c6cb49f3bff66ecf948e14e1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8ee05fb07c5b4536bbed4227057bf307', 'b9d8dc92128e46bca71757d31cbc8aff', '6d883930be1641d4b9a2713a4ec56447')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8ef92f82808c46658472a31bb7119feb', 'b9d8dc92128e46bca71757d31cbc8aff', '5e483c7c626b4364a85bf0ef0ae6aa42')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('8f8019af52a94adb929d3cdad71a2af4', '4640f8c6fe5248c38adcfaa01a55babb', '4e91035f6b3f41a59740de1b74933985')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('90ca20900937408283df4f34e24617d5', 'b9d8dc92128e46bca71757d31cbc8aff', '43abd33dde83442d9ef0d6ed0668e22b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('933dacfcd0b2457a95844852f8259f6c', '4640f8c6fe5248c38adcfaa01a55babb', '5533094c92aa4e3c801f181f9be23ee1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('9358e51fe57d43359711f60abcbaa1ae', 'b9d8dc92128e46bca71757d31cbc8aff', '096a375443f641638aec821fb3bd51b0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('935b64f612aa4034b3cdf354a7b951b0', '4640f8c6fe5248c38adcfaa01a55babb', '2004d1f6327c479fae471a4f8d890b3d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('947fd4ccc2fa4e7fbdced35b6534eafb', '5adaf0ad9ad54703a975c536a94202e3', 'b45e5303ba0d4a84b3f889ace7682f95')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('965e173a67ed412db3ec6e928fce829f', '4640f8c6fe5248c38adcfaa01a55babb', '2321fce09869418fbdcdecffc0154750')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('983e95add71f4b1594a25de9a191876e', '5adaf0ad9ad54703a975c536a94202e3', '4e91035f6b3f41a59740de1b74933985')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('99c0dafc1b6a4eaa8ad3d1ca13cdc4ca', '5adaf0ad9ad54703a975c536a94202e3', '18b8c00a09ff4ab39352da3562693e9d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('9d1a054e4ec5481c870bd33f9aa69ed2', 'b9d8dc92128e46bca71757d31cbc8aff', '284aea685eb7429997dab0a0f91d0d0c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('9e9afc41e7964c89b6b2989b122a4b5f', '5adaf0ad9ad54703a975c536a94202e3', '8a46a0d57322446bbeeceafa5afceb6b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('9f1871fdbf0945eaaf1a70029cdb34f1', '5adaf0ad9ad54703a975c536a94202e3', '096a375443f641638aec821fb3bd51b0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('9feed90c852d48b7aa005d1222d282a9', 'b9d8dc92128e46bca71757d31cbc8aff', 'ee0391be728343a7b38b85e17f39e01d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a0ee2d1dfe1645e6a9216ec753396e2b', '5adaf0ad9ad54703a975c536a94202e3', '2321fce09869418fbdcdecffc0154750')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a13d03f16935434a88b2a3260f70e582', '4640f8c6fe5248c38adcfaa01a55babb', 'ee0391be728343a7b38b85e17f39e01d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a1576455c47b416e83f4fbbe385d34c1', 'b9d8dc92128e46bca71757d31cbc8aff', '674cc9e6d84344d79787d0fe7a0f13e2')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a3488e2db37241f080d0ad35929a4ef2', '5adaf0ad9ad54703a975c536a94202e3', 'f411d6d2fd0a413b8dd303d28d1d88ff')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a3ff90ee9f404e4a89c7b04d440fec04', 'b9d8dc92128e46bca71757d31cbc8aff', '6b93b45f40424494b8714b6ac9ccf758')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a442db18e76b4c28955fdc756df0a8a6', '4640f8c6fe5248c38adcfaa01a55babb', '720c056805414dffa9bc46860d2672da')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a47843e9d5084725a05f4a973370ea2c', 'b9d8dc92128e46bca71757d31cbc8aff', 'aa1da01788d2410c932f382f66d7b9be')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('a703a7e7263e445499db736ae88cd25d', '4640f8c6fe5248c38adcfaa01a55babb', '4e05556478c94685a495bdfa28a27915')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('aac4d63d15074805a657c81759c43aae', 'b9d8dc92128e46bca71757d31cbc8aff', '56a97061cbd4402d91c37d0d5fad9572')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('ae0bf49a149b4f6dacdd9881194541fd', 'b9d8dc92128e46bca71757d31cbc8aff', '2321fce09869418fbdcdecffc0154750')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('b0675bd316af4967888de2e546ddf00b', 'b9d8dc92128e46bca71757d31cbc8aff', 'e6c92e1fd41245649b5f91954de45cf4')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('b1ba14c3bc454b8cb5e8fcd05bb8d5b4', '4640f8c6fe5248c38adcfaa01a55babb', 'a75a65a6b58a45869bb81d8eb46e48ed')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('b5b68c3d63e24170a8c5d823f1870bd5', '5adaf0ad9ad54703a975c536a94202e3', '62a530ee9b994188ae443899bc0da167')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('b5fcab4319674b8c808ae87ced5886fa', '5adaf0ad9ad54703a975c536a94202e3', 'f4f5d09a19d4487489306f8fec5d49a9')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('ba9282b882b94c9eb4fc09c03e7469f3', 'b9d8dc92128e46bca71757d31cbc8aff', 'a75a65a6b58a45869bb81d8eb46e48ed')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('bbf33095fc1b4ebca6eff353dcb8d492', '5adaf0ad9ad54703a975c536a94202e3', '5533094c92aa4e3c801f181f9be23ee1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('bcf8893ea1e649ebb44110aa44728148', '5adaf0ad9ad54703a975c536a94202e3', '10dfe625a74d4131918013a66a6405e6')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('bebf2c6680544883b8385a2228db1096', '5adaf0ad9ad54703a975c536a94202e3', '85b18580ec7b4e65b3fc3a4541c799d4')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('c2cac877d5094b478b63a68fa21fe5e0', '5adaf0ad9ad54703a975c536a94202e3', 'e9a132c01a11497291a8301d38eaaa1f')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('c4e079c35969411e87b3b8b029e95a41', 'b9d8dc92128e46bca71757d31cbc8aff', '8a46a0d57322446bbeeceafa5afceb6b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('c720051d4c41452cb9a004cab0e52b56', '5adaf0ad9ad54703a975c536a94202e3', 'e70b5436f88a48f8ac2fd3743f286153')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('c88dc052cc96484caa5b8f8221c5141b', '4640f8c6fe5248c38adcfaa01a55babb', 'd333441d87b5442d8ad718b31b384642')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('caa78fd7a7d44df69bba428ff6ed4d4e', '4640f8c6fe5248c38adcfaa01a55babb', '17dade74081f415db361fc94c2bd8bec')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('cac9ac7a56be4b88ac9dec601c84c251', '5adaf0ad9ad54703a975c536a94202e3', 'd333441d87b5442d8ad718b31b384642')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('cdc29cfbd7114eaf88fdc94c3a829259', '5adaf0ad9ad54703a975c536a94202e3', '4f732e0dc8bb4541a568e4f512c625eb')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('cde3d6a645844cee884d9b56e74a7dd2', 'b9d8dc92128e46bca71757d31cbc8aff', 'd333441d87b5442d8ad718b31b384642')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('cdf10fc961e44133884240ebb9b13f2f', 'b9d8dc92128e46bca71757d31cbc8aff', 'c7c8229b695a4cd780974a8a9d4281e0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('ce9a9031d0df40cb8acdc33365aefeb0', '5adaf0ad9ad54703a975c536a94202e3', '682c9ecbb1834298aa6ce154b6e82bb6')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('cf8426b11a5548efb87643016686a16c', '5adaf0ad9ad54703a975c536a94202e3', '17dade74081f415db361fc94c2bd8bec')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d0d38c6dfd5940eb98b6254915999c00', 'b9d8dc92128e46bca71757d31cbc8aff', 'e70b5436f88a48f8ac2fd3743f286153')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d0d9755cd05f4e6ab69ba743edeeb50a', '5adaf0ad9ad54703a975c536a94202e3', '203b633107014db1b422ce40dbb8aa34')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d1a470740f0b40b0b0cfb71e70dcbac9', 'b9d8dc92128e46bca71757d31cbc8aff', '17dade74081f415db361fc94c2bd8bec')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d45344503c5c4a32992a7fc69622ea9b', '5adaf0ad9ad54703a975c536a94202e3', '2004d1f6327c479fae471a4f8d890b3d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d55b664e4bf64811bb44b7efec57d61c', 'b9d8dc92128e46bca71757d31cbc8aff', 'a07277b1ad0f4ff1ae16c9525d2db6a1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d58573dfb7fd4ec09aeb11cc7197623f', '4640f8c6fe5248c38adcfaa01a55babb', '674cc9e6d84344d79787d0fe7a0f13e2')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d5beb2908bea408ab37df7c2c82a5cb9', '5adaf0ad9ad54703a975c536a94202e3', 'a07277b1ad0f4ff1ae16c9525d2db6a1')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('d629c9019aed4a528ee1a33a98c4ce5b', 'b9d8dc92128e46bca71757d31cbc8aff', '2fa12d1dc46c42c29dd5c20f8a6cbb9a')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('dba3adbce72b43cc9c2c321ecdb7c6a6', '4640f8c6fe5248c38adcfaa01a55babb', '32e0b981eec9452280b66e4648e31948')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('e56fcc4435cf4c93b17650bcbe010ab6', '5adaf0ad9ad54703a975c536a94202e3', '7a92f4bbd7724f7ea7daf35ac2970ebf')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('e6a07c9f08f84877a3ca323d3ee0278b', '4640f8c6fe5248c38adcfaa01a55babb', '285342ea6d054aa8adca503c799f561d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('e8677f9df20f4ed5914a5ad656d6c19e', 'b9d8dc92128e46bca71757d31cbc8aff', 'c033396876d2441e89cd4a5eeb0cc80c')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('e8c982a3f94a4efa9ae1d4fb2654d9ed', '5adaf0ad9ad54703a975c536a94202e3', 'c7c8229b695a4cd780974a8a9d4281e0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('ea20a536e3844e6a855272582025ce2b', '5adaf0ad9ad54703a975c536a94202e3', 'ee0391be728343a7b38b85e17f39e01d')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('eac68d46544d44a3a2566ffe7470c13a', '5adaf0ad9ad54703a975c536a94202e3', '737a19eb1de1440bab5dfda2769b4c4b')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('edacfa58c5e646e29b67d164ee42a264', '5adaf0ad9ad54703a975c536a94202e3', 'df5ac44d905941808e300f725738d450')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('ede6b04841f44545bbef93d1c870489b', '5adaf0ad9ad54703a975c536a94202e3', '6b93b45f40424494b8714b6ac9ccf758')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('f67c9d6bf57f4c09869e1bc000acc24b', '5adaf0ad9ad54703a975c536a94202e3', 'b793b95bd92147eb9e42eb274dd25d32')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('f6fb2519076f42f9a0271cc32e265e5f', '5adaf0ad9ad54703a975c536a94202e3', '45d4d9c3057f456d98c3eab718df1769')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('f7c7cae9e9cc479d8c58477ef7ae1701', '4640f8c6fe5248c38adcfaa01a55babb', '56a97061cbd4402d91c37d0d5fad9572')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fa3f501494024b69b922eb4332921526', 'b9d8dc92128e46bca71757d31cbc8aff', '62a530ee9b994188ae443899bc0da167')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fb4997f8e77d47b4a1d2d8fb5ab1b971', 'b9d8dc92128e46bca71757d31cbc8aff', '01c2ba9201a94d91a6c96817b4c124e7')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fc3fe5ea71b04a489aeae2c8c621db5e', '5adaf0ad9ad54703a975c536a94202e3', '76eb781ddeb94a38aa25090e32f47aa0')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fddb750dfd6340acb375dad7d850b48e', '4640f8c6fe5248c38adcfaa01a55babb', '45d4d9c3057f456d98c3eab718df1769')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fe66ac9900ab413dbcefd025a685b76c', 'b9d8dc92128e46bca71757d31cbc8aff', '30646d6c7c534de48b10b40181ec61c9')
INSERT [cms_rolepri] ([ROW_ID], [ROLEID], [PRIVILEGEID]) VALUES ('fff1c7dc20ea4c83b93a2bc638a795f2', '5adaf0ad9ad54703a975c536a94202e3', '43abd33dde83442d9ef0d6ed0668e22b')

INSERT [cms_dw] ([ROW_ID], [DWBH], [DWMC], [CONTENT], [UPDATEID], [UPDATETIME], [PREDWID], [STATE], [ACTIVETIME], [PATH], [CHILDREN], [CHILDACTIVETIME], [TEMPLATE], [DWALIAS], [STBNOCOUNT], [TEMPLATE_HB]) VALUES ('772f3c2cb03d406a8e350df27d23fc05', '10', '网站单位', '', '1', NULL, '0', 0, NULL, '772f3c2cb03d406a8e350df27d23fc05,', 0, NULL, 0, '', 0, 0)
INSERT [cms_user] ([ROW_ID], [NAME], [CODE], [PASSWD], [EMAIL], [PHONE], [DES], [STATE], [UPDATEID], [UPDATETIME], [LOGIN], [CREATEID], [CREATTIME], [DWID], [LOGINTIME], [TIMES], [LOGINIP]) VALUES ('e6f59dcb89c0447c835af82bdb00d55b', '管理员', 'admin', '{MD5}ISMvKXpXpadDiUoOSoAfww==', 'admin@admin.com', '', '', 1, '1', NULL, 0, '1', NULL, '772f3c2cb03d406a8e350df27d23fc05', NULL, 21, '')
INSERT [cms_userrole] ([ROW_ID], [USERID], [ROLEID]) VALUES ('8e78333b3f9d4000bd6438914978f998', 'e6f59dcb89c0447c835af82bdb00d55b', '5adaf0ad9ad54703a975c536a94202e3')
INSERT [cms_useractive] ([ROW_ID], [USERID], [USERNAME], [ACTIVETIME], [DWID]) VALUES ('ce61fa34420c45b98e95fca4f315fe24', 'e6f59dcb89c0447c835af82bdb00d55b', '管理员', NULL, '772f3c2cb03d406a8e350df27d23fc05')

INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminuser', 'administrator'); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminpasswd', '{MD5}tZxnvxlqR1gZHkL3ZnDOug=='); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminlastlogin', '2013-06-01 10:01:01'); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminemail', ''); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminphone', ''); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('adminname', '系统管理员'); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('auditflow', '0'); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('badwordenable', '1'); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('badword', ''); 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('sysname', '协同发布系统') ; 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('uploadpath', '') ; 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('counter', '0') ; 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('assort', 'message') ; 
INSERT [cms_variable] ([IDENTITY], [VAL]) VALUES ('copyright', '') ;
GO

/************/
CREATE PROCEDURE [sp_cms_user_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT ROW_ID FROM cms_user WHERE ' + @P_WHERE + ' ORDER BY [CODE] ASC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT cms_user.* FROM cms_user, #temp WHERE cms_user.ROW_ID = #temp.ROW_ID AND #temp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND #temp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY [CODE]  ASC'
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_user_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_user WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_role_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT ROW_ID FROM cms_role WHERE ' + @P_WHERE + ' ORDER BY [NAME] ASC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT cms_role.* FROM cms_role, #temp WHERE cms_role.ROW_ID = #temp.ROW_ID AND #temp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND #temp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY [NAME]  ASC'
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_role_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_role WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_resource_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT ROW_ID FROM cms_resource WHERE ' + @P_WHERE + ' ORDER BY [IDENTITY] ASC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT cms_resource.* FROM cms_resource, #temp WHERE cms_resource.ROW_ID = #temp.ROW_ID AND #temp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND #temp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY [IDENTITY]  ASC'
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_resource_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_resource WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_notice_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_notice a WHERE ' + @P_WHERE + ' ORDER BY a.UPDATETIME DESC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT a.ROW_ID,a.UPDATEID,a.UPDATETIME,a.STATE,a.TITLE,a.HITS FROM cms_notice a, #temp tmp WHERE a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY a.UPDATETIME  DESC'
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_notice_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_notice a WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_messages] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200), 
@P_ORDER VARCHAR(200),
@P_FETCHALL INTEGER
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_message a, cms_article b WHERE a.ARTICLEID = b.ROW_ID AND a.ISOPEN = 1  ' + @P_WHERE + @P_ORDER

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

IF @P_FETCHALL = 1
	BEGIN
	SET @TSQL = 'SELECT a.*, b.TITLE AS ARTICLE,b.AUTHOR,b.SOURCE,b.LINK  FROM cms_message a, cms_article b,  #temp tmp WHERE  a.ARTICLEID = b.ROW_ID AND a.ISOPEN = 1 AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + @P_ORDER 
	END
ELSE
	BEGIN
	SET @TSQL = 'SELECT a.ROW_ID,a.UPDATEID,a.UPDATETIME,a.TITLE,a.CREATETIME,a.WRITER,a.PHONE,a.MOBILE,a.ISOPEN,a.ISDELETED,b.TITLE AS ARTICLE,b.AUTHOR,b.SOURCE,b.LINK FROM cms_message a, cms_article b,  #temp tmp WHERE  a.ARTICLEID = b.ROW_ID AND a.ISOPEN = 1 AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + @P_ORDER 
	END
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_message_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)


SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_message a, cms_dw b, cms_article c WHERE a.DWID = b.ROW_ID AND a.ARTICLEID = c.ROW_ID  ' + @P_WHERE + ' ORDER BY a.CREATETIME DESC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT a.ROW_ID,a.UPDATEID,a.UPDATETIME,a.TITLE,a.CREATETIME,a.WRITER,a.PHONE,a.MOBILE,a.STATE,a.ISOPEN,a.ISDELETED,b.DWMC,c.TITLE AS ARTICLE,c.AUTHOR,c.SOURCE,c.LINK FROM  cms_message a, cms_dw b, cms_article c,  #temp tmp WHERE a.DWID = b.ROW_ID AND a.ARTICLEID = c.ROW_ID AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY a.CREATETIME DESC'
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_member_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_member a WHERE 1 = 1 ' + @P_WHERE 
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_member_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)


SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_member a WHERE 1=1  ' + @P_WHERE + ' ORDER BY a.CREATETIME DESC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT a.* FROM cms_member a, #temp tmp WHERE a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY a.CREATETIME DESC'
EXEC(@TSQL)

GO

/************/
CREATE PROCEDURE [sp_cms_message_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_message a, cms_dw b, cms_article c WHERE a.DWID = b.ROW_ID AND a.ARTICLEID = c.ROW_ID ' + @P_WHERE 
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_log_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)


SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT ROW_ID FROM cms_log WHERE ' + @P_WHERE + ' ORDER BY CREATETIME DESC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT cms_log.* FROM cms_log, #temp WHERE cms_log.ROW_ID = #temp.ROW_ID AND #temp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND #temp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY CREATETIME DESC'
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_log_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_log WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO


/************/
CREATE PROCEDURE [sp_cms_assort_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)


SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT ROW_ID FROM cms_assort WHERE ' + @P_WHERE + ' ORDER BY [NO] ASC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT cms_assort.* FROM cms_assort, #temp WHERE cms_assort.ROW_ID = #temp.ROW_ID AND #temp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND #temp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY [NO]  ASC'
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_assort_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_assort WHERE ' + @P_WHERE 
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_articles] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200), 
@P_ORDER VARCHAR(200),
@P_FETCHALL INTEGER
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)

SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_article a, cms_assort b WHERE a.ASSORTID = b.ROW_ID AND a.STATE = 1  ' + @P_WHERE + @P_ORDER

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

IF @P_FETCHALL = 1
	BEGIN
	SET @TSQL = 'SELECT a.*, b.[NAME], b.[NO]  FROM cms_article a, cms_assort b,  #temp tmp WHERE  a.ASSORTID = b.ROW_ID AND a.STATE = 1 AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + @P_ORDER 
	END
ELSE
	BEGIN
	SET @TSQL = 'SELECT a.ROW_ID,a.ASSORTID,a.TITLE,a.WRITER,a.AUTHOR,a.SOURCE,a.LINK,a.SUMMARY, a.CREATETIME,a.IMG,a.HITS,a.PUBDATE,a.INDATE,b.[NAME],b.[NO] FROM cms_article a, cms_assort b,  #temp tmp WHERE  a.ASSORTID = b.ROW_ID AND a.STATE = 1 AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + @P_ORDER 
	END
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_article_pager] 
@P_START INTEGER, 
@P_SIZE INTEGER,
@P_WHERE NVARCHAR(200)
AS

SET NOCOUNT ON

DECLARE @TSQL NVARCHAR(2000)

CREATE TABLE #temp(
	[ID] BIGINT IDENTITY(1,1) NOT NULL,
	ROW_ID NVARCHAR(32)
)


SET @TSQL = 'INSERT INTO #temp(ROW_ID) SELECT a.ROW_ID FROM cms_article a, cms_dw b, cms_assort c WHERE a.DWID = b.ROW_ID AND a.ASSORTID = c.ROW_ID  ' + @P_WHERE + ' ORDER BY a.CREATETIME DESC'

EXEC(@TSQL)

SET @P_SIZE = @P_START + @P_SIZE

SET @TSQL = 'SELECT a.ROW_ID,a.UPDATEID,a.UPDATETIME,a.STATE,a.TITLE,a.PUBDATE,a.DUTY,a.BACKDES,b.DWMC,c.[NAME] FROM  cms_article a, cms_dw b, cms_assort c,  #temp tmp WHERE a.DWID = b.ROW_ID AND a.ASSORTID = c.ROW_ID AND a.ROW_ID = tmp.ROW_ID AND tmp.[ID] >  ' + CAST(@P_START AS VARCHAR(10)) + ' AND tmp.[ID] <= ' + CAST(@P_SIZE AS VARCHAR(20)) + '  ORDER BY a.CREATETIME DESC'
EXEC(@TSQL)
GO

/************/
CREATE PROCEDURE [sp_cms_article_count] 
@P_WHERE NVARCHAR(200)
AS

DECLARE @TSQL NVARCHAR(2000)
SET @TSQL = 'SELECT COUNT(1) FROM cms_article a, cms_dw b, cms_assort c WHERE a.DWID = b.ROW_ID AND a.ASSORTID = c.ROW_ID ' + @P_WHERE 
EXEC(@TSQL)
GO
